package com.itheima.dao;

import com.itheima.domain.Setmeal;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SetmealDao {

    @Select("SELECT s.`name` ,COUNT(o.`id`) AS VALUE  FROM t_order o ,t_setmeal s WHERE o.`setmeal_id`=s.`id` GROUP BY s.`name`")
    List<Setmeal> findSetmeal();
}